{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv('mdd.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>目的地</th>\n",
       "      <th>类别</th>\n",
       "      <th>文章名称</th>\n",
       "      <th>日期</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>【厦门】厦门是一座岛，那就去环岛骑行,厦门旅游攻略 - 马蜂</td>\n",
       "      <td>2014-05-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>厦门4日游，一个人自由行攻略,厦门旅游攻略 - 马蜂窝</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>海上花园鼓浪屿—福建自驾环行（八）,厦门旅游攻略 - 马蜂窝</td>\n",
       "      <td>2017-11-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>厦门吃吃吃——打卡扫雷篇！,厦门旅游攻略 - 马蜂窝</td>\n",
       "      <td>2017-04-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>厦门---大登岛（老金门县政府驻地）（262）,厦门旅游攻略</td>\n",
       "      <td>2017-12-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>厦门---大登岛“三岛战地观光园（263）,厦门旅游攻略 -</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>厦门环岛沿路景色（266）,厦门旅游攻略 - 马蜂窝</td>\n",
       "      <td>2017-12-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>在厦门邂逅小清新,厦门旅游攻略 - 马蜂窝</td>\n",
       "      <td>2016-11-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>【春遇厦门】愿时光静好，你我如初（多图）,厦门旅游攻略 -</td>\n",
       "      <td>2018-03-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>一个人的厦门小清新文艺之旅［3天4晚］,厦门旅游攻略 - 马</td>\n",
       "      <td>2018-03-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>2017年最新最全的厦门八大必游景点推荐,厦门旅游攻略 -</td>\n",
       "      <td>2017-08-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>厦门四天亲子游，资深本地人推荐的12个好地方,厦门旅游攻略</td>\n",
       "      <td>2018-01-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>我们的厦门亲子游，附带详细攻略,厦门旅游攻略 - 马蜂窝</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>Amoy－夷则五日，浮生未歇,厦门旅游攻略 - 马蜂窝</td>\n",
       "      <td>2017-09-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>跨年游厦门之集美,厦门旅游攻略 - 马蜂窝</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>大俊带我去踏青——厦门泉州,厦门旅游攻略 - 马蜂窝</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>别让时间带走最美的时光——厦门回忆,厦门旅游攻略 - 马蜂窝</td>\n",
       "      <td>2015-06-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>《杀死那个文艺青年》——阿呸的厦门之旅,厦门旅游攻略 - 马</td>\n",
       "      <td>2017-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>厦门美食,厦门旅游攻略 - 马蜂窝</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>香港</td>\n",
       "      <td>游记</td>\n",
       "      <td>香港～网红摄影点打卡,香港旅游攻略 - 马蜂窝</td>\n",
       "      <td>2017-12-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>香港</td>\n",
       "      <td>游记</td>\n",
       "      <td>香港电影取景地一日巡礼-我的文艺港片记忆,香港旅游攻略 -</td>\n",
       "      <td>2015-02-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>香港</td>\n",
       "      <td>游记</td>\n",
       "      <td>香港—这座城市有一颗不会睡去的胃,香港旅游攻略 - 马蜂窝</td>\n",
       "      <td>2017-03-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>香港</td>\n",
       "      <td>游记</td>\n",
       "      <td>MISS MANGO的港式礼拜天,香港旅游攻略 - 马蜂窝</td>\n",
       "      <td>2017-10-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>香港</td>\n",
       "      <td>游记</td>\n",
       "      <td>我的香港旅行故事,香港旅游攻略 - 马蜂窝</td>\n",
       "      <td>2017-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>香港</td>\n",
       "      <td>游记</td>\n",
       "      <td>香港小众玩法｜塔门，石澳，玫瑰的故事,香港旅游攻略 - 马蜂</td>\n",
       "      <td>2017-10-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>香港</td>\n",
       "      <td>游记</td>\n",
       "      <td>香港扎营4天3夜行（元旦期间）,香港旅游攻略 - 马蜂窝</td>\n",
       "      <td>2015-12-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>香港</td>\n",
       "      <td>游记</td>\n",
       "      <td>大暑节气，我带着一部胶片机去了香港,香港旅游攻略 - 马蜂窝</td>\n",
       "      <td>2017-07-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>香港</td>\n",
       "      <td>游记</td>\n",
       "      <td>香港3日游,香港旅游攻略 - 马蜂窝</td>\n",
       "      <td>2018-03-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>拉萨</td>\n",
       "      <td>游记</td>\n",
       "      <td>一路向西  朝圣之旅\\n(成都到拉萨),拉萨旅游攻略 - 马蜂</td>\n",
       "      <td>2017-07-24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>澳大利亚</td>\n",
       "      <td>游记</td>\n",
       "      <td>南半球的阳光初春,澳大利亚旅游攻略 - 马蜂窝</td>\n",
       "      <td>2017-09-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2501</th>\n",
       "      <td>巴基斯坦</td>\n",
       "      <td>游记</td>\n",
       "      <td>《巴铁是怎样炼成的》,巴基斯坦旅游攻略 - 马蜂窝</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2504</th>\n",
       "      <td>米兰</td>\n",
       "      <td>游记</td>\n",
       "      <td>2018.2 MILANO 博物馆们,米兰旅游攻略 - 马蜂</td>\n",
       "      <td>2018-02-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2507</th>\n",
       "      <td>佛山</td>\n",
       "      <td>游记</td>\n",
       "      <td>一天五顿的佛山顺德美食自驾之旅,佛山旅游攻略 - 马蜂窝</td>\n",
       "      <td>2018-04-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2515</th>\n",
       "      <td>连城</td>\n",
       "      <td>游记</td>\n",
       "      <td>连城古村，可谈风月,连城旅游攻略 - 马蜂窝</td>\n",
       "      <td>2018-04-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2526</th>\n",
       "      <td>南疆</td>\n",
       "      <td>游记</td>\n",
       "      <td>从南疆到北疆\\n赴一场杏花之约,南疆旅游攻略 - 马蜂窝</td>\n",
       "      <td>2018-03-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2527</th>\n",
       "      <td>南疆</td>\n",
       "      <td>游记</td>\n",
       "      <td>【南疆十五日】我心所向，是谓南疆,南疆旅游攻略 - 马蜂窝</td>\n",
       "      <td>2017-07-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2528</th>\n",
       "      <td>南疆</td>\n",
       "      <td>游记</td>\n",
       "      <td>间隔年｜这个夏天，我在南疆浪了43天（上）,南疆旅游攻略 -</td>\n",
       "      <td>2017-06-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2529</th>\n",
       "      <td>大峡谷国家公园</td>\n",
       "      <td>游记</td>\n",
       "      <td>西游后记之闺蜜大峡谷取经记,大峡谷国家公园旅游攻略 - 马蜂</td>\n",
       "      <td>2017-10-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2531</th>\n",
       "      <td>明尼苏达州</td>\n",
       "      <td>游记</td>\n",
       "      <td>迷失在明尼苏达雪景中 等待天晴,明尼苏达州旅游攻略 - 马蜂</td>\n",
       "      <td>2017-12-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2533</th>\n",
       "      <td>珀斯</td>\n",
       "      <td>游记</td>\n",
       "      <td>把你的心交给最会治愈的珀斯。,珀斯旅游攻略 - 马蜂窝</td>\n",
       "      <td>2018-04-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2535</th>\n",
       "      <td>巴哈马</td>\n",
       "      <td>游记</td>\n",
       "      <td>这个隆冬，我注定有一个不可抗拒的夏天,巴哈马旅游攻略 - 马</td>\n",
       "      <td>2018-02-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2537</th>\n",
       "      <td>西昌</td>\n",
       "      <td>游记</td>\n",
       "      <td>大凉山系列之二    \\n黄联土林,西昌旅游攻略 - 马蜂窝</td>\n",
       "      <td>2013-11-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2542</th>\n",
       "      <td>白马庄园</td>\n",
       "      <td>游记</td>\n",
       "      <td>品味法式优雅——白马庄园10天9晚亲子游,白马庄园旅游攻略</td>\n",
       "      <td>2016-06-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2548</th>\n",
       "      <td>西岭雪山</td>\n",
       "      <td>游记</td>\n",
       "      <td>行记_西岭雪山——2日摄影之旅,西岭雪山旅游攻略 - 马蜂窝</td>\n",
       "      <td>2018-01-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2553</th>\n",
       "      <td>乐山</td>\n",
       "      <td>游记</td>\n",
       "      <td>乐山-乐享味蕾,乐山旅游攻略 - 马蜂窝</td>\n",
       "      <td>2018-04-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2554</th>\n",
       "      <td>加拿大落基山国家公园群</td>\n",
       "      <td>游记</td>\n",
       "      <td>一次沿着落基山脉的旅行,加拿大落基山国家公园群旅游攻略 -</td>\n",
       "      <td>2017-09-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2559</th>\n",
       "      <td>荆门</td>\n",
       "      <td>游记</td>\n",
       "      <td>陕鄂行记之任性的皇帝 任性的皇陵,荆门旅游攻略 - 马蜂窝</td>\n",
       "      <td>2018-03-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2561</th>\n",
       "      <td>温哥华</td>\n",
       "      <td>游记</td>\n",
       "      <td>你带着我漂洋过海，体验23天的加拿大海岛生活,温哥华旅游攻略</td>\n",
       "      <td>2017-08-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2563</th>\n",
       "      <td>龙里</td>\n",
       "      <td>游记</td>\n",
       "      <td>风抚金浪——加榜梯田秋收正当时,龙里旅游攻略 - 马蜂窝</td>\n",
       "      <td>2017-09-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2568</th>\n",
       "      <td>恩和</td>\n",
       "      <td>游记</td>\n",
       "      <td>恩和-七卡行进在边防路上，我们依然在呼伦贝尔！,恩和旅游攻略</td>\n",
       "      <td>2017-07-26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2582</th>\n",
       "      <td>长崎</td>\n",
       "      <td>游记</td>\n",
       "      <td>去长崎平户寻找好滋味，探索浮在海上的纯真与质朴,长崎旅游攻略</td>\n",
       "      <td>2017-11-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2583</th>\n",
       "      <td>亚特兰大</td>\n",
       "      <td>游记</td>\n",
       "      <td>无车无伴四日游 _ 历史的残酷与温柔,亚特兰大旅游攻略 -</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2584</th>\n",
       "      <td>双鱼岛</td>\n",
       "      <td>游记</td>\n",
       "      <td>带着老妈去看海 ——马尔代夫双鱼岛,双鱼岛旅游攻略 - 马蜂</td>\n",
       "      <td>2014-07-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2585</th>\n",
       "      <td>瓦纳卡</td>\n",
       "      <td>游记</td>\n",
       "      <td>瓦纳卡徒步奇遇（新西兰）,瓦纳卡旅游攻略 - 马蜂窝</td>\n",
       "      <td>2018-03-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2588</th>\n",
       "      <td>靖西</td>\n",
       "      <td>游记</td>\n",
       "      <td>心愿心随----八桂之西，不期长留,靖西旅游攻略 - 马蜂窝</td>\n",
       "      <td>2014-09-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2600</th>\n",
       "      <td>湘西</td>\n",
       "      <td>游记</td>\n",
       "      <td>边城往事  ▏2017湘西自驾行,湘西旅游攻略 - 马蜂窝</td>\n",
       "      <td>2017-10-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2603</th>\n",
       "      <td>哈利法克斯</td>\n",
       "      <td>游记</td>\n",
       "      <td>行摄哈利法克斯——追寻蓝海幻梦的应许之地,哈利法克斯旅游攻略</td>\n",
       "      <td>2017-07-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2610</th>\n",
       "      <td>都匀</td>\n",
       "      <td>游记</td>\n",
       "      <td>黔东南的山水，一首唱不完的歌,都匀旅游攻略 - 马蜂窝</td>\n",
       "      <td>2017-10-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2616</th>\n",
       "      <td>釜山</td>\n",
       "      <td>游记</td>\n",
       "      <td>达达的韩国釜山摄影之旅,釜山旅游攻略 - 马蜂窝</td>\n",
       "      <td>2017-03-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2623</th>\n",
       "      <td>霞浦</td>\n",
       "      <td>游记</td>\n",
       "      <td>观山海，嘻游记（霞浦 三沙 花竹 东壁）,霞浦旅游攻略 -</td>\n",
       "      <td>2017-05-28</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>479 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              目的地  类别                             文章名称          日期\n",
       "21             厦门  游记   【厦门】厦门是一座岛，那就去环岛骑行,厦门旅游攻略 - 马蜂  2014-05-07\n",
       "23             厦门  游记      厦门4日游，一个人自由行攻略,厦门旅游攻略 - 马蜂窝         NaN\n",
       "24             厦门  游记   海上花园鼓浪屿—福建自驾环行（八）,厦门旅游攻略 - 马蜂窝  2017-11-09\n",
       "25             厦门  游记       厦门吃吃吃——打卡扫雷篇！,厦门旅游攻略 - 马蜂窝  2017-04-29\n",
       "30             厦门  游记   厦门---大登岛（老金门县政府驻地）（262）,厦门旅游攻略  2017-12-02\n",
       "31             厦门  游记   厦门---大登岛“三岛战地观光园（263）,厦门旅游攻略 -         NaN\n",
       "33             厦门  游记       厦门环岛沿路景色（266）,厦门旅游攻略 - 马蜂窝  2017-12-02\n",
       "38             厦门  游记            在厦门邂逅小清新,厦门旅游攻略 - 马蜂窝  2016-11-12\n",
       "45             厦门  游记   【春遇厦门】愿时光静好，你我如初（多图）,厦门旅游攻略 -   2018-03-14\n",
       "47             厦门  游记   一个人的厦门小清新文艺之旅［3天4晚］,厦门旅游攻略 - 马  2018-03-13\n",
       "48             厦门  游记   2017年最新最全的厦门八大必游景点推荐,厦门旅游攻略 -   2017-08-14\n",
       "49             厦门  游记   厦门四天亲子游，资深本地人推荐的12个好地方,厦门旅游攻略   2018-01-09\n",
       "50             厦门  游记     我们的厦门亲子游，附带详细攻略,厦门旅游攻略 - 马蜂窝         NaN\n",
       "52             厦门  游记      Amoy－夷则五日，浮生未歇,厦门旅游攻略 - 马蜂窝  2017-09-13\n",
       "53             厦门  游记            跨年游厦门之集美,厦门旅游攻略 - 马蜂窝         NaN\n",
       "55             厦门  游记       大俊带我去踏青——厦门泉州,厦门旅游攻略 - 马蜂窝         NaN\n",
       "57             厦门  游记   别让时间带走最美的时光——厦门回忆,厦门旅游攻略 - 马蜂窝  2015-06-04\n",
       "60             厦门  游记   《杀死那个文艺青年》——阿呸的厦门之旅,厦门旅游攻略 - 马  2017-01-01\n",
       "61             厦门  游记                厦门美食,厦门旅游攻略 - 马蜂窝         NaN\n",
       "82             香港  游记          香港～网红摄影点打卡,香港旅游攻略 - 马蜂窝  2017-12-06\n",
       "84             香港  游记   香港电影取景地一日巡礼-我的文艺港片记忆,香港旅游攻略 -   2015-02-01\n",
       "89             香港  游记    香港—这座城市有一颗不会睡去的胃,香港旅游攻略 - 马蜂窝  2017-03-21\n",
       "99             香港  游记    MISS MANGO的港式礼拜天,香港旅游攻略 - 马蜂窝  2017-10-01\n",
       "100            香港  游记            我的香港旅行故事,香港旅游攻略 - 马蜂窝  2017-10-05\n",
       "101            香港  游记   香港小众玩法｜塔门，石澳，玫瑰的故事,香港旅游攻略 - 马蜂  2017-10-12\n",
       "108            香港  游记     香港扎营4天3夜行（元旦期间）,香港旅游攻略 - 马蜂窝  2015-12-31\n",
       "109            香港  游记   大暑节气，我带着一部胶片机去了香港,香港旅游攻略 - 马蜂窝  2017-07-22\n",
       "116            香港  游记               香港3日游,香港旅游攻略 - 马蜂窝  2018-03-29\n",
       "122            拉萨  游记  一路向西  朝圣之旅\\n(成都到拉萨),拉萨旅游攻略 - 马蜂  2017-07-24\n",
       "143          澳大利亚  游记          南半球的阳光初春,澳大利亚旅游攻略 - 马蜂窝  2017-09-29\n",
       "...           ...  ..                              ...         ...\n",
       "2501         巴基斯坦  游记        《巴铁是怎样炼成的》,巴基斯坦旅游攻略 - 马蜂窝         NaN\n",
       "2504           米兰  游记   2018.2 MILANO 博物馆们,米兰旅游攻略 - 马蜂  2018-02-22\n",
       "2507           佛山  游记     一天五顿的佛山顺德美食自驾之旅,佛山旅游攻略 - 马蜂窝  2018-04-05\n",
       "2515           连城  游记           连城古村，可谈风月,连城旅游攻略 - 马蜂窝  2018-04-16\n",
       "2526           南疆  游记     从南疆到北疆\\n赴一场杏花之约,南疆旅游攻略 - 马蜂窝  2018-03-31\n",
       "2527           南疆  游记    【南疆十五日】我心所向，是谓南疆,南疆旅游攻略 - 马蜂窝  2017-07-29\n",
       "2528           南疆  游记   间隔年｜这个夏天，我在南疆浪了43天（上）,南疆旅游攻略 -  2017-06-25\n",
       "2529      大峡谷国家公园  游记   西游后记之闺蜜大峡谷取经记,大峡谷国家公园旅游攻略 - 马蜂  2017-10-27\n",
       "2531        明尼苏达州  游记   迷失在明尼苏达雪景中 等待天晴,明尼苏达州旅游攻略 - 马蜂  2017-12-15\n",
       "2533           珀斯  游记      把你的心交给最会治愈的珀斯。,珀斯旅游攻略 - 马蜂窝  2018-04-20\n",
       "2535          巴哈马  游记   这个隆冬，我注定有一个不可抗拒的夏天,巴哈马旅游攻略 - 马  2018-02-17\n",
       "2537           西昌  游记   大凉山系列之二    \\n黄联土林,西昌旅游攻略 - 马蜂窝  2013-11-02\n",
       "2542         白马庄园  游记   品味法式优雅——白马庄园10天9晚亲子游,白马庄园旅游攻略   2016-06-13\n",
       "2548         西岭雪山  游记   行记_西岭雪山——2日摄影之旅,西岭雪山旅游攻略 - 马蜂窝  2018-01-08\n",
       "2553           乐山  游记             乐山-乐享味蕾,乐山旅游攻略 - 马蜂窝  2018-04-05\n",
       "2554  加拿大落基山国家公园群  游记   一次沿着落基山脉的旅行,加拿大落基山国家公园群旅游攻略 -   2017-09-16\n",
       "2559           荆门  游记    陕鄂行记之任性的皇帝 任性的皇陵,荆门旅游攻略 - 马蜂窝  2018-03-06\n",
       "2561          温哥华  游记   你带着我漂洋过海，体验23天的加拿大海岛生活,温哥华旅游攻略  2017-08-03\n",
       "2563           龙里  游记     风抚金浪——加榜梯田秋收正当时,龙里旅游攻略 - 马蜂窝  2017-09-22\n",
       "2568           恩和  游记   恩和-七卡行进在边防路上，我们依然在呼伦贝尔！,恩和旅游攻略  2017-07-26\n",
       "2582           长崎  游记   去长崎平户寻找好滋味，探索浮在海上的纯真与质朴,长崎旅游攻略  2017-11-11\n",
       "2583         亚特兰大  游记   无车无伴四日游 _ 历史的残酷与温柔,亚特兰大旅游攻略 -          NaN\n",
       "2584          双鱼岛  游记   带着老妈去看海 ——马尔代夫双鱼岛,双鱼岛旅游攻略 - 马蜂  2014-07-03\n",
       "2585          瓦纳卡  游记       瓦纳卡徒步奇遇（新西兰）,瓦纳卡旅游攻略 - 马蜂窝  2018-03-16\n",
       "2588           靖西  游记   心愿心随----八桂之西，不期长留,靖西旅游攻略 - 马蜂窝  2014-09-20\n",
       "2600           湘西  游记    边城往事  ▏2017湘西自驾行,湘西旅游攻略 - 马蜂窝  2017-10-01\n",
       "2603        哈利法克斯  游记   行摄哈利法克斯——追寻蓝海幻梦的应许之地,哈利法克斯旅游攻略  2017-07-01\n",
       "2610           都匀  游记      黔东南的山水，一首唱不完的歌,都匀旅游攻略 - 马蜂窝  2017-10-01\n",
       "2616           釜山  游记         达达的韩国釜山摄影之旅,釜山旅游攻略 - 马蜂窝  2017-03-08\n",
       "2623           霞浦  游记   观山海，嘻游记（霞浦 三沙 花竹 东壁）,霞浦旅游攻略 -   2017-05-28\n",
       "\n",
       "[479 rows x 4 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['文章名称'].str.contains('旅游攻略')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['文章名称-1']=df['文章名称']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['文章名称-1']=df['文章名称-1'].str.replace('自助游攻略','旅游攻略')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>目的地</th>\n",
       "      <th>类别</th>\n",
       "      <th>文章名称</th>\n",
       "      <th>日期</th>\n",
       "      <th>文章名称-1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [目的地, 类别, 文章名称, 日期, 文章名称-1]\n",
       "Index: []"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['文章名称-1'].duplicated()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>目的地</th>\n",
       "      <th>类别</th>\n",
       "      <th>文章名称</th>\n",
       "      <th>日期</th>\n",
       "      <th>文章名称-1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1570</th>\n",
       "      <td>青海</td>\n",
       "      <td>自由行</td>\n",
       "      <td>茶卡盐湖全攻略（附摄影指南）2017修订版 - 马蜂窝</td>\n",
       "      <td>2017-03-24</td>\n",
       "      <td>茶卡盐湖全攻略（附摄影指南）2017修订版 - 马蜂窝</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2617</th>\n",
       "      <td>乌兰</td>\n",
       "      <td>自由行</td>\n",
       "      <td>茶卡盐湖全攻略（附摄影指南）2017修订版 - 马蜂窝</td>\n",
       "      <td>2017-03-24</td>\n",
       "      <td>茶卡盐湖全攻略（附摄影指南）2017修订版 - 马蜂窝</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     目的地   类别                         文章名称          日期  \\\n",
       "1570  青海  自由行  茶卡盐湖全攻略（附摄影指南）2017修订版 - 马蜂窝  2017-03-24   \n",
       "2617  乌兰  自由行  茶卡盐湖全攻略（附摄影指南）2017修订版 - 马蜂窝  2017-03-24   \n",
       "\n",
       "                           文章名称-1  \n",
       "1570  茶卡盐湖全攻略（附摄影指南）2017修订版 - 马蜂窝  \n",
       "2617  茶卡盐湖全攻略（附摄影指南）2017修订版 - 马蜂窝  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['文章名称-1']=='茶卡盐湖全攻略（附摄影指南）2017修订版 - 马蜂窝']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.drop_duplicates('文章名称-1',inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.fillna(method='ffill',inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.loc[df['目的地']=='厦门','其他']=123"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>目的地</th>\n",
       "      <th>类别</th>\n",
       "      <th>文章名称</th>\n",
       "      <th>日期</th>\n",
       "      <th>文章名称-1</th>\n",
       "      <th>其他</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>厦门</td>\n",
       "      <td>自由行</td>\n",
       "      <td>如果只有72小时，我会这样带你玩遍厦门经典~ - 马蜂窝</td>\n",
       "      <td>2018-01-06</td>\n",
       "      <td>如果只有72小时，我会这样带你玩遍厦门经典~ - 马蜂窝</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>厦门</td>\n",
       "      <td>自由行</td>\n",
       "      <td>厦门食神之路：最全美食攻略，如何完美的吃下一座城 - 马蜂窝</td>\n",
       "      <td>2018-01-18</td>\n",
       "      <td>厦门食神之路：最全美食攻略，如何完美的吃下一座城 - 马蜂窝</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>厦门</td>\n",
       "      <td>自由行</td>\n",
       "      <td>厦门吃喝玩乐全体验，这才是旅行的正经事 - 马蜂窝</td>\n",
       "      <td>2018-02-23</td>\n",
       "      <td>厦门吃喝玩乐全体验，这才是旅行的正经事 - 马蜂窝</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>厦门</td>\n",
       "      <td>自由行</td>\n",
       "      <td>厦门的温泉不可错过！看本地人常去的温泉有哪些 - 马蜂窝</td>\n",
       "      <td>2016-11-23</td>\n",
       "      <td>厦门的温泉不可错过！看本地人常去的温泉有哪些 - 马蜂窝</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>厦门</td>\n",
       "      <td>自由行</td>\n",
       "      <td>别不小心去错了土楼，选前必读，土楼2018最新攻略 - 马蜂</td>\n",
       "      <td>2017-11-20</td>\n",
       "      <td>别不小心去错了土楼，选前必读，土楼2018最新攻略 - 马蜂</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>厦门</td>\n",
       "      <td>自由行</td>\n",
       "      <td>美食攻略丨在厦门八市，50块钱吃到你撑的飞不起来 - 马蜂窝</td>\n",
       "      <td>2018-01-18</td>\n",
       "      <td>美食攻略丨在厦门八市，50块钱吃到你撑的飞不起来 - 马蜂窝</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>厦门</td>\n",
       "      <td>自由行</td>\n",
       "      <td>友生沙茶面，老板是厦门当年的第一潮人｜食客 - 马蜂窝</td>\n",
       "      <td>2017-12-26</td>\n",
       "      <td>友生沙茶面，老板是厦门当年的第一潮人｜食客 - 马蜂窝</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>厦门</td>\n",
       "      <td>自由行</td>\n",
       "      <td>厦门亲子游 _带孩子来厦门这样玩，大人孩子都开心 - 马蜂窝</td>\n",
       "      <td>2016-12-02</td>\n",
       "      <td>厦门亲子游 _带孩子来厦门这样玩，大人孩子都开心 - 马蜂窝</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>厦门</td>\n",
       "      <td>自由行</td>\n",
       "      <td>强势种草！厦门5种徒步新玩法，寻觅历史韵味 - 马蜂窝</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>强势种草！厦门5种徒步新玩法，寻觅历史韵味 - 马蜂窝</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>厦门</td>\n",
       "      <td>自由行</td>\n",
       "      <td>云水谣+田螺坑，想去最经典的土楼就来这两个~ - 马蜂窝</td>\n",
       "      <td>2018-03-14</td>\n",
       "      <td>云水谣+田螺坑，想去最经典的土楼就来这两个~ - 马蜂窝</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>厦门</td>\n",
       "      <td>自由行</td>\n",
       "      <td>有“老城情结”的你，适合逛逛这6条厦门街巷 - 马蜂窝</td>\n",
       "      <td>2017-12-11</td>\n",
       "      <td>有“老城情结”的你，适合逛逛这6条厦门街巷 - 马蜂窝</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>厦门</td>\n",
       "      <td>自由行</td>\n",
       "      <td>去厦门前必看，教你吃喝玩乐不走弯路（附上岛信息） - 马蜂窝</td>\n",
       "      <td>2016-12-05</td>\n",
       "      <td>去厦门前必看，教你吃喝玩乐不走弯路（附上岛信息） - 马蜂窝</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>厦门</td>\n",
       "      <td>自由行</td>\n",
       "      <td>东山岛玩法揭秘︱《左耳》拍摄地，这的海无比纯净 - 马蜂窝</td>\n",
       "      <td>2017-07-07</td>\n",
       "      <td>东山岛玩法揭秘︱《左耳》拍摄地，这的海无比纯净 - 马蜂窝</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>厦门</td>\n",
       "      <td>自由行</td>\n",
       "      <td>去土楼前，有哪些不得不看的防“套路”指南？ - 马蜂窝</td>\n",
       "      <td>2017-06-26</td>\n",
       "      <td>去土楼前，有哪些不得不看的防“套路”指南？ - 马蜂窝</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>厦门</td>\n",
       "      <td>自由行</td>\n",
       "      <td>厦门的网红店，多在沙坡尾！ - 马蜂窝</td>\n",
       "      <td>2017-10-16</td>\n",
       "      <td>厦门的网红店，多在沙坡尾！ - 马蜂窝</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>厦门</td>\n",
       "      <td>自由行</td>\n",
       "      <td>这真的是一版正！宗！的厦门小吃攻略（Part 1） - 马蜂</td>\n",
       "      <td>2017-12-04</td>\n",
       "      <td>这真的是一版正！宗！的厦门小吃攻略（Part 1） - 马蜂</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>厦门</td>\n",
       "      <td>自由行</td>\n",
       "      <td>老厦门街头美味，要市井、要地道就来这！ - 马蜂窝</td>\n",
       "      <td>2017-10-24</td>\n",
       "      <td>老厦门街头美味，要市井、要地道就来这！ - 马蜂窝</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>厦门</td>\n",
       "      <td>自由行</td>\n",
       "      <td>闽南人带着你逛吃厦门不重样！（附本地人推荐美食） - 马蜂窝</td>\n",
       "      <td>2016-11-02</td>\n",
       "      <td>闽南人带着你逛吃厦门不重样！（附本地人推荐美食） - 马蜂窝</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>厦门</td>\n",
       "      <td>自由行</td>\n",
       "      <td>厦门秘制五花烤大肉，西边社上天乐撸｜食客 - 马蜂窝</td>\n",
       "      <td>2017-12-29</td>\n",
       "      <td>厦门秘制五花烤大肉，西边社上天乐撸｜食客 - 马蜂窝</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>5岁混血萝莉，鹭岛卖萌之旅——四天三夜亲子游厦门,厦门自助游</td>\n",
       "      <td>2018-01-12</td>\n",
       "      <td>5岁混血萝莉，鹭岛卖萌之旅——四天三夜亲子游厦门,厦门自助游</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>春季厦门，这次玩个够（内含厦门岛·鼓浪屿·镇海角·云水谣土楼</td>\n",
       "      <td>2018-03-23</td>\n",
       "      <td>春季厦门，这次玩个够（内含厦门岛·鼓浪屿·镇海角·云水谣土楼</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>【厦门】厦门是一座岛，那就去环岛骑行,厦门旅游攻略 - 马蜂</td>\n",
       "      <td>2014-05-07</td>\n",
       "      <td>【厦门】厦门是一座岛，那就去环岛骑行,厦门旅游攻略 - 马蜂</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>春暖花开的时候，厦门逛吃去～,厦门自助游攻略 - 马蜂窝</td>\n",
       "      <td>2018-03-27</td>\n",
       "      <td>春暖花开的时候，厦门逛吃去～,厦门旅游攻略 - 马蜂窝</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>厦门4日游，一个人自由行攻略,厦门旅游攻略 - 马蜂窝</td>\n",
       "      <td>2018-03-27</td>\n",
       "      <td>厦门4日游，一个人自由行攻略,厦门旅游攻略 - 马蜂窝</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>海上花园鼓浪屿—福建自驾环行（八）,厦门旅游攻略 - 马蜂窝</td>\n",
       "      <td>2017-11-09</td>\n",
       "      <td>海上花园鼓浪屿—福建自驾环行（八）,厦门旅游攻略 - 马蜂窝</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>厦门吃吃吃——打卡扫雷篇！,厦门旅游攻略 - 马蜂窝</td>\n",
       "      <td>2017-04-29</td>\n",
       "      <td>厦门吃吃吃——打卡扫雷篇！,厦门旅游攻略 - 马蜂窝</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>台风过境，依旧明媚的Amoy。如梦记忆。,厦门自助游攻略 -</td>\n",
       "      <td>2016-09-30</td>\n",
       "      <td>台风过境，依旧明媚的Amoy。如梦记忆。,厦门旅游攻略 -</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>跟着_老厦门_走遍这20家隐秘的地道小吃店，真正的美食在这里</td>\n",
       "      <td>2018-04-04</td>\n",
       "      <td>跟着_老厦门_走遍这20家隐秘的地道小吃店，真正的美食在这里</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>谁说去厦门一定要去鼓浪屿？—记厦门岛的四天三夜,厦门自助游攻</td>\n",
       "      <td>2017-06-02</td>\n",
       "      <td>谁说去厦门一定要去鼓浪屿？—记厦门岛的四天三夜,厦门自助游攻</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>厦门</td>\n",
       "      <td>游记</td>\n",
       "      <td>逛～吃～厦门五晚六天自由行,厦门自助游攻略 - 马蜂窝</td>\n",
       "      <td>2017-11-06</td>\n",
       "      <td>逛～吃～厦门五晚六天自由行,厦门旅游攻略 - 马蜂窝</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2600</th>\n",
       "      <td>湘西</td>\n",
       "      <td>游记</td>\n",
       "      <td>边城往事  ▏2017湘西自驾行,湘西旅游攻略 - 马蜂窝</td>\n",
       "      <td>2017-10-01</td>\n",
       "      <td>边城往事  ▏2017湘西自驾行,湘西旅游攻略 - 马蜂窝</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2601</th>\n",
       "      <td>奥臻岛</td>\n",
       "      <td>自由行</td>\n",
       "      <td>马尔代夫新晋网红一价全包奢华岛--奥臻岛 - 马蜂窝</td>\n",
       "      <td>2017-12-07</td>\n",
       "      <td>马尔代夫新晋网红一价全包奢华岛--奥臻岛 - 马蜂窝</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2602</th>\n",
       "      <td>东欧</td>\n",
       "      <td>游记</td>\n",
       "      <td>❤塑料姐妹花 东欧愉快耍❤ 捷奥匈三国懒散游记与实用干货攻略</td>\n",
       "      <td>2017-05-27</td>\n",
       "      <td>❤塑料姐妹花 东欧愉快耍❤ 捷奥匈三国懒散游记与实用干货攻略</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2603</th>\n",
       "      <td>哈利法克斯</td>\n",
       "      <td>游记</td>\n",
       "      <td>行摄哈利法克斯——追寻蓝海幻梦的应许之地,哈利法克斯旅游攻略</td>\n",
       "      <td>2017-07-01</td>\n",
       "      <td>行摄哈利法克斯——追寻蓝海幻梦的应许之地,哈利法克斯旅游攻略</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2604</th>\n",
       "      <td>清莱</td>\n",
       "      <td>自由行</td>\n",
       "      <td>泰国清迈玩腻了，那就来清莱吧 - 马蜂窝</td>\n",
       "      <td>2017-08-22</td>\n",
       "      <td>泰国清迈玩腻了，那就来清莱吧 - 马蜂窝</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2605</th>\n",
       "      <td>珠海</td>\n",
       "      <td>自由行</td>\n",
       "      <td>玩遍这些才算来过珠海横琴长隆度假区！（含景点推荐） - 马蜂</td>\n",
       "      <td>2016-08-22</td>\n",
       "      <td>玩遍这些才算来过珠海横琴长隆度假区！（含景点推荐） - 马蜂</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2606</th>\n",
       "      <td>巢湖</td>\n",
       "      <td>游记</td>\n",
       "      <td>环“心型”巢湖自驾，去合肥后花园逛一逛文艺“耳街”,巢湖自助</td>\n",
       "      <td>2018-01-13</td>\n",
       "      <td>环“心型”巢湖自驾，去合肥后花园逛一逛文艺“耳街”,巢湖自助</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2607</th>\n",
       "      <td>山西</td>\n",
       "      <td>游记</td>\n",
       "      <td>清明七日独驾——环游山西半省,山西自助游攻略 - 马蜂窝</td>\n",
       "      <td>2018-03-31</td>\n",
       "      <td>清明七日独驾——环游山西半省,山西旅游攻略 - 马蜂窝</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2608</th>\n",
       "      <td>拜县</td>\n",
       "      <td>自由行</td>\n",
       "      <td>小清新必去的拜县，有哪些必打卡的好去处？ - 马蜂窝</td>\n",
       "      <td>2017-03-21</td>\n",
       "      <td>小清新必去的拜县，有哪些必打卡的好去处？ - 马蜂窝</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2609</th>\n",
       "      <td>普罗旺斯</td>\n",
       "      <td>自由行</td>\n",
       "      <td>去普罗旺斯看薰衣草，把心留在最浪漫的花海！ - 马蜂窝</td>\n",
       "      <td>2017-03-23</td>\n",
       "      <td>去普罗旺斯看薰衣草，把心留在最浪漫的花海！ - 马蜂窝</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2610</th>\n",
       "      <td>都匀</td>\n",
       "      <td>游记</td>\n",
       "      <td>黔东南的山水，一首唱不完的歌,都匀旅游攻略 - 马蜂窝</td>\n",
       "      <td>2017-10-01</td>\n",
       "      <td>黔东南的山水，一首唱不完的歌,都匀旅游攻略 - 马蜂窝</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2611</th>\n",
       "      <td>非洲</td>\n",
       "      <td>自由行</td>\n",
       "      <td>奏响野性狂想曲：穿越非洲大陆指南 - 马蜂窝</td>\n",
       "      <td>2017-11-22</td>\n",
       "      <td>奏响野性狂想曲：穿越非洲大陆指南 - 马蜂窝</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2612</th>\n",
       "      <td>格拉纳达</td>\n",
       "      <td>自由行</td>\n",
       "      <td>格拉纳达超全攻略，内含【阿尔罕布拉宫】详尽介绍 - 马蜂窝</td>\n",
       "      <td>2017-08-30</td>\n",
       "      <td>格拉纳达超全攻略，内含【阿尔罕布拉宫】详尽介绍 - 马蜂窝</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2613</th>\n",
       "      <td>都江堰</td>\n",
       "      <td>自由行</td>\n",
       "      <td>吸氧避霾，成都周边一日游必去都江堰和青城外山 - 马蜂窝</td>\n",
       "      <td>2017-07-27</td>\n",
       "      <td>吸氧避霾，成都周边一日游必去都江堰和青城外山 - 马蜂窝</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2614</th>\n",
       "      <td>都江堰</td>\n",
       "      <td>自由行</td>\n",
       "      <td>乐山峨眉山与都江堰青城山，成都周边山水究竟哪家强？ - 马蜂</td>\n",
       "      <td>2017-09-15</td>\n",
       "      <td>乐山峨眉山与都江堰青城山，成都周边山水究竟哪家强？ - 马蜂</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2615</th>\n",
       "      <td>加那利群岛</td>\n",
       "      <td>游记</td>\n",
       "      <td>¡Hola!鸡血少女一个人玩转非洲西属兰萨罗特岛和大加那利岛</td>\n",
       "      <td>2016-10-27</td>\n",
       "      <td>¡Hola!鸡血少女一个人玩转非洲西属兰萨罗特岛和大加那利岛</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2616</th>\n",
       "      <td>釜山</td>\n",
       "      <td>游记</td>\n",
       "      <td>达达的韩国釜山摄影之旅,釜山旅游攻略 - 马蜂窝</td>\n",
       "      <td>2017-03-08</td>\n",
       "      <td>达达的韩国釜山摄影之旅,釜山旅游攻略 - 马蜂窝</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2618</th>\n",
       "      <td>宫岛</td>\n",
       "      <td>自由行</td>\n",
       "      <td>外国游客心中的日本第一，竟然是这个女神居住的小岛！ - 马蜂</td>\n",
       "      <td>2017-03-31</td>\n",
       "      <td>外国游客心中的日本第一，竟然是这个女神居住的小岛！ - 马蜂</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2619</th>\n",
       "      <td>巴中</td>\n",
       "      <td>游记</td>\n",
       "      <td>为了那秋天的童话，三上光雾山,巴中自助游攻略 - 马蜂窝</td>\n",
       "      <td>2017-10-28</td>\n",
       "      <td>为了那秋天的童话，三上光雾山,巴中旅游攻略 - 马蜂窝</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2620</th>\n",
       "      <td>广州长隆旅游度假区</td>\n",
       "      <td>游记</td>\n",
       "      <td>说走就走的旅行——带娃舒适双园游～广州长隆野生动物园➕珠海横</td>\n",
       "      <td>2018-04-07</td>\n",
       "      <td>说走就走的旅行——带娃舒适双园游～广州长隆野生动物园➕珠海横</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2621</th>\n",
       "      <td>米尔福德峡湾</td>\n",
       "      <td>游记</td>\n",
       "      <td>2016年4月 新西兰南岛十二天游之(六)：米尓福德峡湾、蒂</td>\n",
       "      <td>2016-04-17</td>\n",
       "      <td>2016年4月 新西兰南岛十二天游之(六)：米尓福德峡湾、蒂</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2622</th>\n",
       "      <td>安徽</td>\n",
       "      <td>自由行</td>\n",
       "      <td>安徽为什么喜欢换省会？ - 马蜂窝</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>安徽为什么喜欢换省会？ - 马蜂窝</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2623</th>\n",
       "      <td>霞浦</td>\n",
       "      <td>游记</td>\n",
       "      <td>观山海，嘻游记（霞浦 三沙 花竹 东壁）,霞浦旅游攻略 -</td>\n",
       "      <td>2017-05-28</td>\n",
       "      <td>观山海，嘻游记（霞浦 三沙 花竹 东壁）,霞浦旅游攻略 -</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2624</th>\n",
       "      <td>霞浦</td>\n",
       "      <td>游记</td>\n",
       "      <td>福建霞浦清明三日游,霞浦自助游攻略 - 马蜂窝</td>\n",
       "      <td>2018-04-04</td>\n",
       "      <td>福建霞浦清明三日游,霞浦旅游攻略 - 马蜂窝</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2625</th>\n",
       "      <td>拉普兰</td>\n",
       "      <td>自由行</td>\n",
       "      <td>拉普兰美食推荐_ 吃过这几样，才算来过芬兰 - 马蜂窝</td>\n",
       "      <td>2017-10-09</td>\n",
       "      <td>拉普兰美食推荐_ 吃过这几样，才算来过芬兰 - 马蜂窝</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2626</th>\n",
       "      <td>波特兰</td>\n",
       "      <td>游记</td>\n",
       "      <td>被遗忘的小清新－－爱上俄勒冈的五天四夜＃火山口湖索尔之井＃,</td>\n",
       "      <td>2017-08-28</td>\n",
       "      <td>被遗忘的小清新－－爱上俄勒冈的五天四夜＃火山口湖索尔之井＃,</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2627</th>\n",
       "      <td>清远</td>\n",
       "      <td>自由行</td>\n",
       "      <td>不可错过！来清远必玩的6大体验！ - 马蜂窝</td>\n",
       "      <td>2017-01-04</td>\n",
       "      <td>不可错过！来清远必玩的6大体验！ - 马蜂窝</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2628</th>\n",
       "      <td>辛辛那提</td>\n",
       "      <td>游记</td>\n",
       "      <td>冬日辛辛那提的五個故事 (Cincinnati Winter</td>\n",
       "      <td>2018-01-07</td>\n",
       "      <td>冬日辛辛那提的五個故事 (Cincinnati Winter</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2629</th>\n",
       "      <td>黎巴嫩</td>\n",
       "      <td>游记</td>\n",
       "      <td>No.43 富游黎巴嫩出乎意料Lebanon＋附加餐馆推荐,</td>\n",
       "      <td>2017-12-04</td>\n",
       "      <td>No.43 富游黎巴嫩出乎意料Lebanon＋附加餐馆推荐,</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2630</th>\n",
       "      <td>红河</td>\n",
       "      <td>游记</td>\n",
       "      <td>滇越铁路的《芳华》——碧色寨火车站的法国梦,红河自助游攻略</td>\n",
       "      <td>2012-01-29</td>\n",
       "      <td>滇越铁路的《芳华》——碧色寨火车站的法国梦,红河旅游攻略</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2592 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            目的地   类别                            文章名称          日期  \\\n",
       "0            厦门  自由行    如果只有72小时，我会这样带你玩遍厦门经典~ - 马蜂窝  2018-01-06   \n",
       "1            厦门  自由行  厦门食神之路：最全美食攻略，如何完美的吃下一座城 - 马蜂窝  2018-01-18   \n",
       "2            厦门  自由行       厦门吃喝玩乐全体验，这才是旅行的正经事 - 马蜂窝  2018-02-23   \n",
       "3            厦门  自由行    厦门的温泉不可错过！看本地人常去的温泉有哪些 - 马蜂窝  2016-11-23   \n",
       "4            厦门  自由行  别不小心去错了土楼，选前必读，土楼2018最新攻略 - 马蜂  2017-11-20   \n",
       "5            厦门  自由行  美食攻略丨在厦门八市，50块钱吃到你撑的飞不起来 - 马蜂窝  2018-01-18   \n",
       "6            厦门  自由行     友生沙茶面，老板是厦门当年的第一潮人｜食客 - 马蜂窝  2017-12-26   \n",
       "7            厦门  自由行  厦门亲子游 _带孩子来厦门这样玩，大人孩子都开心 - 马蜂窝  2016-12-02   \n",
       "8            厦门  自由行     强势种草！厦门5种徒步新玩法，寻觅历史韵味 - 马蜂窝  2017-10-31   \n",
       "9            厦门  自由行    云水谣+田螺坑，想去最经典的土楼就来这两个~ - 马蜂窝  2018-03-14   \n",
       "10           厦门  自由行     有“老城情结”的你，适合逛逛这6条厦门街巷 - 马蜂窝  2017-12-11   \n",
       "11           厦门  自由行  去厦门前必看，教你吃喝玩乐不走弯路（附上岛信息） - 马蜂窝  2016-12-05   \n",
       "12           厦门  自由行   东山岛玩法揭秘︱《左耳》拍摄地，这的海无比纯净 - 马蜂窝  2017-07-07   \n",
       "13           厦门  自由行     去土楼前，有哪些不得不看的防“套路”指南？ - 马蜂窝  2017-06-26   \n",
       "14           厦门  自由行             厦门的网红店，多在沙坡尾！ - 马蜂窝  2017-10-16   \n",
       "15           厦门  自由行  这真的是一版正！宗！的厦门小吃攻略（Part 1） - 马蜂  2017-12-04   \n",
       "16           厦门  自由行       老厦门街头美味，要市井、要地道就来这！ - 马蜂窝  2017-10-24   \n",
       "17           厦门  自由行  闽南人带着你逛吃厦门不重样！（附本地人推荐美食） - 马蜂窝  2016-11-02   \n",
       "18           厦门  自由行      厦门秘制五花烤大肉，西边社上天乐撸｜食客 - 马蜂窝  2017-12-29   \n",
       "19           厦门   游记  5岁混血萝莉，鹭岛卖萌之旅——四天三夜亲子游厦门,厦门自助游  2018-01-12   \n",
       "20           厦门   游记  春季厦门，这次玩个够（内含厦门岛·鼓浪屿·镇海角·云水谣土楼  2018-03-23   \n",
       "21           厦门   游记  【厦门】厦门是一座岛，那就去环岛骑行,厦门旅游攻略 - 马蜂  2014-05-07   \n",
       "22           厦门   游记    春暖花开的时候，厦门逛吃去～,厦门自助游攻略 - 马蜂窝  2018-03-27   \n",
       "23           厦门   游记     厦门4日游，一个人自由行攻略,厦门旅游攻略 - 马蜂窝  2018-03-27   \n",
       "24           厦门   游记  海上花园鼓浪屿—福建自驾环行（八）,厦门旅游攻略 - 马蜂窝  2017-11-09   \n",
       "25           厦门   游记      厦门吃吃吃——打卡扫雷篇！,厦门旅游攻略 - 马蜂窝  2017-04-29   \n",
       "26           厦门   游记  台风过境，依旧明媚的Amoy。如梦记忆。,厦门自助游攻略 -  2016-09-30   \n",
       "27           厦门   游记  跟着_老厦门_走遍这20家隐秘的地道小吃店，真正的美食在这里  2018-04-04   \n",
       "28           厦门   游记  谁说去厦门一定要去鼓浪屿？—记厦门岛的四天三夜,厦门自助游攻  2017-06-02   \n",
       "29           厦门   游记     逛～吃～厦门五晚六天自由行,厦门自助游攻略 - 马蜂窝  2017-11-06   \n",
       "...         ...  ...                             ...         ...   \n",
       "2600         湘西   游记   边城往事  ▏2017湘西自驾行,湘西旅游攻略 - 马蜂窝  2017-10-01   \n",
       "2601        奥臻岛  自由行      马尔代夫新晋网红一价全包奢华岛--奥臻岛 - 马蜂窝  2017-12-07   \n",
       "2602         东欧   游记  ❤塑料姐妹花 东欧愉快耍❤ 捷奥匈三国懒散游记与实用干货攻略  2017-05-27   \n",
       "2603      哈利法克斯   游记  行摄哈利法克斯——追寻蓝海幻梦的应许之地,哈利法克斯旅游攻略  2017-07-01   \n",
       "2604         清莱  自由行            泰国清迈玩腻了，那就来清莱吧 - 马蜂窝  2017-08-22   \n",
       "2605         珠海  自由行  玩遍这些才算来过珠海横琴长隆度假区！（含景点推荐） - 马蜂  2016-08-22   \n",
       "2606         巢湖   游记  环“心型”巢湖自驾，去合肥后花园逛一逛文艺“耳街”,巢湖自助  2018-01-13   \n",
       "2607         山西   游记    清明七日独驾——环游山西半省,山西自助游攻略 - 马蜂窝  2018-03-31   \n",
       "2608         拜县  自由行      小清新必去的拜县，有哪些必打卡的好去处？ - 马蜂窝  2017-03-21   \n",
       "2609       普罗旺斯  自由行     去普罗旺斯看薰衣草，把心留在最浪漫的花海！ - 马蜂窝  2017-03-23   \n",
       "2610         都匀   游记     黔东南的山水，一首唱不完的歌,都匀旅游攻略 - 马蜂窝  2017-10-01   \n",
       "2611         非洲  自由行          奏响野性狂想曲：穿越非洲大陆指南 - 马蜂窝  2017-11-22   \n",
       "2612       格拉纳达  自由行   格拉纳达超全攻略，内含【阿尔罕布拉宫】详尽介绍 - 马蜂窝  2017-08-30   \n",
       "2613        都江堰  自由行    吸氧避霾，成都周边一日游必去都江堰和青城外山 - 马蜂窝  2017-07-27   \n",
       "2614        都江堰  自由行  乐山峨眉山与都江堰青城山，成都周边山水究竟哪家强？ - 马蜂  2017-09-15   \n",
       "2615      加那利群岛   游记  ¡Hola!鸡血少女一个人玩转非洲西属兰萨罗特岛和大加那利岛  2016-10-27   \n",
       "2616         釜山   游记        达达的韩国釜山摄影之旅,釜山旅游攻略 - 马蜂窝  2017-03-08   \n",
       "2618         宫岛  自由行  外国游客心中的日本第一，竟然是这个女神居住的小岛！ - 马蜂  2017-03-31   \n",
       "2619         巴中   游记    为了那秋天的童话，三上光雾山,巴中自助游攻略 - 马蜂窝  2017-10-28   \n",
       "2620  广州长隆旅游度假区   游记  说走就走的旅行——带娃舒适双园游～广州长隆野生动物园➕珠海横  2018-04-07   \n",
       "2621     米尔福德峡湾   游记  2016年4月 新西兰南岛十二天游之(六)：米尓福德峡湾、蒂  2016-04-17   \n",
       "2622         安徽  自由行               安徽为什么喜欢换省会？ - 马蜂窝  2017-10-31   \n",
       "2623         霞浦   游记  观山海，嘻游记（霞浦 三沙 花竹 东壁）,霞浦旅游攻略 -   2017-05-28   \n",
       "2624         霞浦   游记         福建霞浦清明三日游,霞浦自助游攻略 - 马蜂窝  2018-04-04   \n",
       "2625        拉普兰  自由行     拉普兰美食推荐_ 吃过这几样，才算来过芬兰 - 马蜂窝  2017-10-09   \n",
       "2626        波特兰   游记  被遗忘的小清新－－爱上俄勒冈的五天四夜＃火山口湖索尔之井＃,  2017-08-28   \n",
       "2627         清远  自由行          不可错过！来清远必玩的6大体验！ - 马蜂窝  2017-01-04   \n",
       "2628       辛辛那提   游记  冬日辛辛那提的五個故事 (Cincinnati Winter  2018-01-07   \n",
       "2629        黎巴嫩   游记  No.43 富游黎巴嫩出乎意料Lebanon＋附加餐馆推荐,  2017-12-04   \n",
       "2630         红河   游记  滇越铁路的《芳华》——碧色寨火车站的法国梦,红河自助游攻略   2012-01-29   \n",
       "\n",
       "                              文章名称-1     其他  \n",
       "0       如果只有72小时，我会这样带你玩遍厦门经典~ - 马蜂窝  123.0  \n",
       "1     厦门食神之路：最全美食攻略，如何完美的吃下一座城 - 马蜂窝  123.0  \n",
       "2          厦门吃喝玩乐全体验，这才是旅行的正经事 - 马蜂窝  123.0  \n",
       "3       厦门的温泉不可错过！看本地人常去的温泉有哪些 - 马蜂窝  123.0  \n",
       "4     别不小心去错了土楼，选前必读，土楼2018最新攻略 - 马蜂  123.0  \n",
       "5     美食攻略丨在厦门八市，50块钱吃到你撑的飞不起来 - 马蜂窝  123.0  \n",
       "6        友生沙茶面，老板是厦门当年的第一潮人｜食客 - 马蜂窝  123.0  \n",
       "7     厦门亲子游 _带孩子来厦门这样玩，大人孩子都开心 - 马蜂窝  123.0  \n",
       "8        强势种草！厦门5种徒步新玩法，寻觅历史韵味 - 马蜂窝  123.0  \n",
       "9       云水谣+田螺坑，想去最经典的土楼就来这两个~ - 马蜂窝  123.0  \n",
       "10       有“老城情结”的你，适合逛逛这6条厦门街巷 - 马蜂窝  123.0  \n",
       "11    去厦门前必看，教你吃喝玩乐不走弯路（附上岛信息） - 马蜂窝  123.0  \n",
       "12     东山岛玩法揭秘︱《左耳》拍摄地，这的海无比纯净 - 马蜂窝  123.0  \n",
       "13       去土楼前，有哪些不得不看的防“套路”指南？ - 马蜂窝  123.0  \n",
       "14               厦门的网红店，多在沙坡尾！ - 马蜂窝  123.0  \n",
       "15    这真的是一版正！宗！的厦门小吃攻略（Part 1） - 马蜂  123.0  \n",
       "16         老厦门街头美味，要市井、要地道就来这！ - 马蜂窝  123.0  \n",
       "17    闽南人带着你逛吃厦门不重样！（附本地人推荐美食） - 马蜂窝  123.0  \n",
       "18        厦门秘制五花烤大肉，西边社上天乐撸｜食客 - 马蜂窝  123.0  \n",
       "19    5岁混血萝莉，鹭岛卖萌之旅——四天三夜亲子游厦门,厦门自助游  123.0  \n",
       "20    春季厦门，这次玩个够（内含厦门岛·鼓浪屿·镇海角·云水谣土楼  123.0  \n",
       "21    【厦门】厦门是一座岛，那就去环岛骑行,厦门旅游攻略 - 马蜂  123.0  \n",
       "22       春暖花开的时候，厦门逛吃去～,厦门旅游攻略 - 马蜂窝  123.0  \n",
       "23       厦门4日游，一个人自由行攻略,厦门旅游攻略 - 马蜂窝  123.0  \n",
       "24    海上花园鼓浪屿—福建自驾环行（八）,厦门旅游攻略 - 马蜂窝  123.0  \n",
       "25        厦门吃吃吃——打卡扫雷篇！,厦门旅游攻略 - 马蜂窝  123.0  \n",
       "26     台风过境，依旧明媚的Amoy。如梦记忆。,厦门旅游攻略 -  123.0  \n",
       "27    跟着_老厦门_走遍这20家隐秘的地道小吃店，真正的美食在这里  123.0  \n",
       "28    谁说去厦门一定要去鼓浪屿？—记厦门岛的四天三夜,厦门自助游攻  123.0  \n",
       "29        逛～吃～厦门五晚六天自由行,厦门旅游攻略 - 马蜂窝  123.0  \n",
       "...                              ...    ...  \n",
       "2600   边城往事  ▏2017湘西自驾行,湘西旅游攻略 - 马蜂窝    NaN  \n",
       "2601      马尔代夫新晋网红一价全包奢华岛--奥臻岛 - 马蜂窝    NaN  \n",
       "2602  ❤塑料姐妹花 东欧愉快耍❤ 捷奥匈三国懒散游记与实用干货攻略    NaN  \n",
       "2603  行摄哈利法克斯——追寻蓝海幻梦的应许之地,哈利法克斯旅游攻略    NaN  \n",
       "2604            泰国清迈玩腻了，那就来清莱吧 - 马蜂窝    NaN  \n",
       "2605  玩遍这些才算来过珠海横琴长隆度假区！（含景点推荐） - 马蜂    NaN  \n",
       "2606  环“心型”巢湖自驾，去合肥后花园逛一逛文艺“耳街”,巢湖自助    NaN  \n",
       "2607     清明七日独驾——环游山西半省,山西旅游攻略 - 马蜂窝    NaN  \n",
       "2608      小清新必去的拜县，有哪些必打卡的好去处？ - 马蜂窝    NaN  \n",
       "2609     去普罗旺斯看薰衣草，把心留在最浪漫的花海！ - 马蜂窝    NaN  \n",
       "2610     黔东南的山水，一首唱不完的歌,都匀旅游攻略 - 马蜂窝    NaN  \n",
       "2611          奏响野性狂想曲：穿越非洲大陆指南 - 马蜂窝    NaN  \n",
       "2612   格拉纳达超全攻略，内含【阿尔罕布拉宫】详尽介绍 - 马蜂窝    NaN  \n",
       "2613    吸氧避霾，成都周边一日游必去都江堰和青城外山 - 马蜂窝    NaN  \n",
       "2614  乐山峨眉山与都江堰青城山，成都周边山水究竟哪家强？ - 马蜂    NaN  \n",
       "2615  ¡Hola!鸡血少女一个人玩转非洲西属兰萨罗特岛和大加那利岛    NaN  \n",
       "2616        达达的韩国釜山摄影之旅,釜山旅游攻略 - 马蜂窝    NaN  \n",
       "2618  外国游客心中的日本第一，竟然是这个女神居住的小岛！ - 马蜂    NaN  \n",
       "2619     为了那秋天的童话，三上光雾山,巴中旅游攻略 - 马蜂窝    NaN  \n",
       "2620  说走就走的旅行——带娃舒适双园游～广州长隆野生动物园➕珠海横    NaN  \n",
       "2621  2016年4月 新西兰南岛十二天游之(六)：米尓福德峡湾、蒂    NaN  \n",
       "2622               安徽为什么喜欢换省会？ - 马蜂窝    NaN  \n",
       "2623  观山海，嘻游记（霞浦 三沙 花竹 东壁）,霞浦旅游攻略 -     NaN  \n",
       "2624          福建霞浦清明三日游,霞浦旅游攻略 - 马蜂窝    NaN  \n",
       "2625     拉普兰美食推荐_ 吃过这几样，才算来过芬兰 - 马蜂窝    NaN  \n",
       "2626  被遗忘的小清新－－爱上俄勒冈的五天四夜＃火山口湖索尔之井＃,    NaN  \n",
       "2627          不可错过！来清远必玩的6大体验！ - 马蜂窝    NaN  \n",
       "2628  冬日辛辛那提的五個故事 (Cincinnati Winter    NaN  \n",
       "2629  No.43 富游黎巴嫩出乎意料Lebanon＋附加餐馆推荐,    NaN  \n",
       "2630   滇越铁路的《芳华》——碧色寨火车站的法国梦,红河旅游攻略     NaN  \n",
       "\n",
       "[2592 rows x 6 columns]"
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1=df.groupby('目的地')['类别'].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "'Series' object has no attribute 'order'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-109-863974babc2d>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mdf1\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0morder\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m/Users/thunderlz/anaconda/lib/python3.6/site-packages/pandas/core/generic.py\u001b[0m in \u001b[0;36m__getattr__\u001b[0;34m(self, name)\u001b[0m\n\u001b[1;32m   2968\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mname\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_info_axis\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2969\u001b[0m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mname\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2970\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mobject\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m__getattribute__\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mname\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2971\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2972\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m__setattr__\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mname\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mAttributeError\u001b[0m: 'Series' object has no attribute 'order'"
     ]
    }
   ],
   "source": [
    "df1.order"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
